Adding a Data Warehouse

The data warehouse is used to expose information stored inside a SQL database using the standard search and data extraction endpoint. This endpoint exposes data using OData standards. Any number of warehouses may be created for a single community.

For example:

Follow these steps to create a data warehouse.

On the Interoperability Service Properties dialog, select the Data Warehouse tab, and then right-click in a blank area of the window and select Add Data Source, for example:

The Data Warehouse Endpoint Wizard dialog appears.
Click Next.
Select Use current community database as warehouse to use the current community’s database context and list all the tables and views to be used as exposed OData entities and then click Next.

Tip: To use a different database, clear the selection and go to Step 7.
Select the Database Server from the list and then click Next.

Note: A data warehouse must be a Microsoft SQL database.
Enter the Username and Password for the database, and click Next.

Note: The user must have Read access to the database, including schema information.
Select the database to which the data source will reference, and then click Next. For example,
Enter a Warehouse Name and then click Next.

Note: The warehouse name is case sensitive when querying the endpoint.

Tip: Multiple warehouses may be created using a single database.
Select all tables and views that should be exposed using the OData provider, and then click Next to complete the wizard.

Note: If the current community was selected as the warehouse, it is recommended to not expose the transactional tables as this may negatively impact performance.
Click Close to close the Data Warehouse Endpoint Wizard.

The data warehouse is created.